/*     */ package com.yc.dao.station;
/*     */ 
/*     */ import btsm.bean.dbConnector;
/*     */ import com.yc.dao.model.BTSBO;
/*     */ import com.yc.dao.model.BTSNewBO;
/*     */ import com.yc.util.FormateSQL;
/*     */ import com.yc.util.ListContentsBFO;
/*     */ import java.sql.ResultSet;
/*     */ import java.text.SimpleDateFormat;
/*     */ import java.util.ArrayList;
/*     */ import java.util.Date;
/*     */ import java.util.List;
/*     */ import java.util.Map;
/*     */ import org.apache.commons.logging.Log;
/*     */ import org.apache.commons.logging.LogFactory;
/*     */ 
/*     */ public class BTSDAO
/*     */ {
/*  22 */   private static final Log log = LogFactory.getLog(BTSDAO.class);
/*     */ 
/*  24 */   private dbConnector dbcon = null;
/*  25 */   private SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
/*  26 */   private SimpleDateFormat sdfNet = new SimpleDateFormat("yyyy-MM-dd");
/*     */ 
/*     */   private void dbConInit() {
/*  29 */     if (this.dbcon == null)
/*  30 */       this.dbcon = new dbConnector();
/*     */   }
/*     */ 
/*     */   private void dbConClose() {
/*  34 */     if (this.dbcon != null)
/*  35 */       this.dbcon.closeAll();
/*  36 */     this.dbcon = null;
/*     */   }
/*     */ 
/*     */   public ListContentsBFO getBTSList(Map condition)
/*     */   {
/*  41 */     ListContentsBFO bfo = new ListContentsBFO();
/*  42 */     int start = Integer.parseInt(condition.get("start").toString());
/*  43 */     int limit = Integer.parseInt(condition.get("limit").toString());
/*  44 */     String strBtscode = condition.get("BTS_CODE").toString();
/*  45 */     ResultSet rs = null;
/*  46 */     List list = new ArrayList();
/*     */     try
/*     */     {
/*  49 */       dbConInit();
/*  50 */       String strSQL = " select count(id) from bts where btscode = '" + strBtscode + "' ";
/*  51 */       log.info(strSQL);
/*  52 */       rs = this.dbcon.execQuery(strSQL);
/*  53 */       if (rs.next()) {
/*  54 */         bfo.setTotalSize(rs.getInt(1));
/*     */       }
/*  56 */       strSQL = " select * from bts where btscode ='" + strBtscode + "' limit " + start + ", " + limit;
/*  57 */       log.info(strSQL);
/*  58 */       rs = this.dbcon.execQuery(strSQL);
/*  59 */       while (rs.next()) {
/*  60 */         BTSBO bo = new BTSBO();
/*  61 */         bo.setId(rs.getString("id"));
/*  62 */         bo.setBtscode(rs.getString("btscode"));
/*  63 */         bo.setBtsname(rs.getString("btsname"));
/*  64 */         bo.setFrequency(rs.getString("frequency"));
/*  65 */         bo.setManufacturer(rs.getString("manufacturer"));
/*  66 */         bo.setMaintenanceT(rs.getString("maintenanceT"));
/*  67 */         bo.setBtstype(rs.getString("btstype"));
/*  68 */         bo.setPrimdevicetype(rs.getString("primdevicetype"));
/*     */ 
/*  70 */         bo.setCellNum(rs.getString("cellNum"));
/*  71 */         bo.setBSC(rs.getString("BSC"));
/*  72 */         bo.setIsVIP(rs.getString("isVIP"));
/*  73 */         bo.setCabinet(rs.getString("cabinet"));
/*  74 */         bo.setBtscfg(rs.getString("btscfg"));
/*  75 */         bo.setFrequencyNum(rs.getString("frequencyNum"));
/*  76 */         bo.setNettingtime(rs.getDate("nettingtime"));
/*     */ 
/*  78 */         bo.setPrimdevicemodel(rs.getString("primdevicemodel"));
/*  79 */         bo.setEle2Mnum(rs.getString("ele2Mnum"));
/*  80 */         bo.setPrimdevicehis(rs.getString("primdevicehis"));
/*     */ 
/*  82 */         bo.setEriZPTRU(rs.getString("eriZPTRU"));
/*  83 */         bo.setEriZPSTRU(rs.getString("eriZPSTRU"));
/*  84 */         bo.setEriZPDTRU(rs.getString("eriZPDTRU"));
/*  85 */         bo.setEriZPOther(rs.getString("eriZPOther"));
/*  86 */         bo.setEriHFCDUA(rs.getString("eriHFCDUA"));
/*  87 */         bo.setEriHFCDUCP(rs.getString("eriHFCDUCP"));
/*  88 */         bo.setEriHFCDUC(rs.getString("eriHFCDUC"));
/*  89 */         bo.setEriHFCDUD(rs.getString("eriHFCDUD"));
/*  90 */         bo.setEriHFCDUF9(rs.getString("eriHFCDUF9"));
/*  91 */         bo.setEriHFCDUG9(rs.getString("eriHFCDUG9"));
/*  92 */         bo.setEriHFOther(rs.getString("eriHFOther"));
/*  93 */         bo.setEriDUX21(rs.getString("eriDUX21"));
/*  94 */         bo.setEriDUX11(rs.getString("eriDUX11"));
/*  95 */         bo.setEriDUX01(rs.getString("eriDUX01"));
/*  96 */         bo.setEriDUXOther(rs.getString("eriDUXOther"));
/*     */ 
/*  98 */         bo.setHWZPTRU(rs.getString("HWZPTRU"));
/*  99 */         bo.setHWZPDRU(rs.getString("HWZPDRU"));
/* 100 */         bo.setHWZPDTRU(rs.getString("HWZPDTRU"));
/* 101 */         bo.setHWZPOther(rs.getString("HWZPOther"));
/* 102 */         bo.setHWHFCDUM900(rs.getString("HWHFCDUM900"));
/* 103 */         bo.setHWHFOther(rs.getString("HWHFOther"));
/* 104 */         bo.setHWHFOther1(rs.getString("HWHFOther1"));
/* 105 */         bo.setHWHFOther2(rs.getString("HWHFOther2"));
/* 106 */         bo.setHWTMU(rs.getString("HWTMU"));
/* 107 */         bo.setHWTMUOther(rs.getString("HWTMUOther"));
/* 108 */         bo.setHWPMU(rs.getString("HWPMU"));
/* 109 */         bo.setHWPMUOther(rs.getString("HWPMUOther"));
/* 110 */         bo.setHWPSU(rs.getString("HWPSU"));
/* 111 */         bo.setHWPSUOther(rs.getString("HWPSUOther"));
/*     */ 
/* 113 */         bo.setRefreshtime(rs.getDate("refreshtime"));
/* 114 */         bo.setMemo(rs.getString("memo"));
/* 115 */         bo.setSbtstype(rs.getString("sbtstype"));
/* 116 */         bo.setIsgovandarm(rs.getString("isgovandarm"));
/* 117 */         bo.setIsmainoroth(rs.getString("ismainoroth"));
/*     */ 
/* 120 */         list.add(bo);
/*     */       }
/* 122 */       bfo.setData(list.toArray());
/*     */     }
/*     */     catch (Exception e) {
/* 125 */       e.printStackTrace();
/* 126 */       log.error(e.getMessage());
/*     */     }
/*     */     finally {
/* 129 */       dbConClose();
/*     */     }
/* 131 */     return bfo;
/*     */   }
/*     */ 
/*     */   public ListContentsBFO getBTSNewBOList(Map condition)
/*     */   {
/* 138 */     ListContentsBFO bfo = new ListContentsBFO();
/* 139 */     int start = Integer.parseInt(condition.get("start").toString());
/* 140 */     int limit = Integer.parseInt(condition.get("limit").toString());
/* 141 */     String strBtscode = condition.get("BTS_CODE").toString();
/* 142 */     ResultSet rs = null;
/* 143 */     List list = new ArrayList();
/*     */     try
/*     */     {
/* 146 */       dbConInit();
/* 147 */       String strSQL = " select count(id) from bts_new where btscode = '" + strBtscode + "' ";
/* 148 */       log.info(strSQL);
/* 149 */       rs = this.dbcon.execQuery(strSQL);
/* 150 */       if (rs.next()) {
/* 151 */         bfo.setTotalSize(rs.getInt(1));
/*     */       }
/* 153 */       strSQL = " select * from bts_new where btscode ='" + strBtscode + "' limit " + start + ", " + limit;
/* 154 */       log.info(strSQL);
/* 155 */       rs = this.dbcon.execQuery(strSQL);
/* 156 */       while (rs.next()) {
/* 157 */         BTSNewBO bo = new BTSNewBO();
/* 158 */         bo.setId(rs.getString("id"));
/* 159 */         bo.setBtsname(rs.getString("btsname"));
/* 160 */         bo.setFrequency(rs.getString("frequency"));
/* 161 */         bo.setBtscode(rs.getString("btscode"));
/* 162 */         bo.setBSC(rs.getString("BSC"));
/* 163 */         bo.setManufacturer(rs.getString("manufacturer"));
/* 164 */         bo.setCabinet(rs.getString("cabinet"));
/* 165 */         bo.setPrimdevicetype(rs.getString("primdevicetype"));
/* 166 */         bo.setBtscfg(rs.getString("btscfg"));
/* 167 */         bo.setFrequencyNum(rs.getString("frequencyNum"));
/* 168 */         bo.setCombinerType(rs.getString("combinerType"));
/* 169 */         bo.setCombinerNum(rs.getString("combinerNum"));
/* 170 */         bo.setPrimContrmodel(rs.getString("primContrmodel"));
/* 171 */         bo.setPrimContrNum(rs.getString("primContrNum"));
/* 172 */         bo.setPowerPanelType(rs.getString("powerPanelType"));
/* 173 */         bo.setPowerPanelNum(rs.getString("powerPanelNum"));
/* 174 */         bo.setPowerType(rs.getString("powerType"));
/* 175 */         bo.setEle2Mnum(rs.getString("ele2Mnum"));
/* 176 */         bo.setRegisttime(rs.getDate("registtime"));
/* 177 */         bo.setAntennaType(rs.getString("antennaType"));
/* 178 */         bo.setAntennaFac(rs.getString("antennaFac"));
/* 179 */         bo.setAntennaNum(rs.getString("antennaNum"));
/* 180 */         bo.setAntennaGain(rs.getString("antennaGain"));
/* 181 */         bo.setAntennaDirect(rs.getString("antennaDirect"));
/* 182 */         bo.setAntennaPolar(rs.getString("antennaPolar"));
/* 183 */         bo.setAntennaHeight(rs.getString("antennaHeight"));
/* 184 */         bo.setAntennaPre(rs.getString("antennaPre"));
/* 185 */         bo.setAntennaAngle(rs.getString("antennaAngle"));
/* 186 */         bo.setAntennaPitchAngle(rs.getString("antennaPitchAngle"));
/* 187 */         bo.setFeederType(rs.getString("feederType"));
/* 188 */         bo.setOther1(rs.getString("other1"));
/* 189 */         bo.setOther2(rs.getString("other2"));
/* 190 */         bo.setOther3(rs.getString("other3"));
/* 191 */         bo.setOther4(rs.getString("other4"));
/* 192 */         bo.setIDUType(rs.getString("IDUType"));
/* 193 */         bo.setIDUNum(rs.getString("IDUNum"));
/* 194 */         bo.setODUType(rs.getString("ODUType"));
/* 195 */         bo.setODUNum(rs.getString("ODUNum"));
/* 196 */         bo.setRefreshtime(rs.getDate("refreshtime"));
/* 197 */         bo.setMemo(rs.getString("memo"));
/* 198 */         list.add(bo);
/*     */       }
/* 200 */       bfo.setData(list.toArray());
/*     */     }
/*     */     catch (Exception e) {
/* 203 */       e.printStackTrace();
/* 204 */       log.error(e.getMessage());
/*     */     }
/*     */     finally {
/* 207 */       dbConClose();
/*     */     }
/* 209 */     return bfo;
/*     */   }
/*     */ 
/*     */   public boolean saveBTS(BTSBO bo)
/*     */   {
/* 215 */     log.info("添加--BTS---开始");
/* 216 */     boolean flag = true;
/*     */     try
/*     */     {
/* 219 */       dbConInit();
/* 220 */       StringBuffer sqlBuf = new StringBuffer();
/* 221 */       sqlBuf.append(" insert into bts ( btscode, btsname, frequency, manufacturer, maintenanceT,");
/* 222 */       sqlBuf.append(" btstype, primdevicetype, cellNum, BSC,  isVIP, cabinet, btscfg, frequencyNum,");
/* 223 */       sqlBuf.append(" nettingtime, primdevicemodel, ele2Mnum, primdevicehis, eriZPTRU, eriZPSTRU,");
/* 224 */       sqlBuf.append(" eriZPDTRU, eriZPOther, eriHFCDUA, eriHFCDUCP, eriHFCDUC, eriHFCDUD, eriHFCDUF9,");
/*     */ 
/* 226 */       sqlBuf.append(" eriHFCDUG9, eriHFOther, eriDUX21, eriDUX11, eriDUX01, eriDUXOther, HWZPTRU,");
/* 227 */       sqlBuf.append(" HWZPDRU, HWZPDTRU, HWZPOther, HWHFCDUM900, HWHFOther, HWHFOther1, HWHFOther2,");
/* 228 */       sqlBuf.append(" HWTMU, HWTMUOther, HWPMU, HWPMUOther, HWPSU, HWPSUOther, refreshtime, memo, ");
/* 229 */       sqlBuf.append(" sbtstype, isgovandarm, ismainoroth ) values ( ");
/* 230 */       sqlBuf.append(" '" + bo.getBtscode() + "' ,");
/* 231 */       sqlBuf.append(" '" + bo.getBtsname() + "' ,");
/* 232 */       sqlBuf.append(" '" + bo.getFrequency() + "' ,");
/* 233 */       sqlBuf.append(" '" + bo.getManufacturer() + "' ,");
/* 234 */       sqlBuf.append(" '" + bo.getMaintenanceT() + "' ,");
/* 235 */       sqlBuf.append(" '" + bo.getBtstype() + "' ,");
/* 236 */       sqlBuf.append(" '" + bo.getPrimdevicetype() + "' ,");
/* 237 */       sqlBuf.append(" '" + bo.getCellNum() + "' ,");
/* 238 */       sqlBuf.append(" '" + bo.getBSC() + "' ,");
/* 239 */       sqlBuf.append(" '" + bo.getIsVIP() + "' ,");
/* 240 */       sqlBuf.append(" '" + bo.getCabinet() + "' ,");
/* 241 */       sqlBuf.append(" '" + bo.getBtscfg() + "' ,");
/* 242 */       sqlBuf.append(" '" + bo.getFrequencyNum() + "' ,");
/* 243 */       sqlBuf.append(" '" + this.sdfNet.format(bo.getNettingtime()) + "' ,");
/* 244 */       sqlBuf.append(" '" + bo.getPrimdevicemodel() + "' ,");
/* 245 */       sqlBuf.append(" '" + bo.getEle2Mnum() + "' ,");
/* 246 */       sqlBuf.append(" '" + bo.getPrimdevicehis() + "' ,");
/* 247 */       sqlBuf.append(" '" + bo.getEriZPTRU() + "' ,");
/* 248 */       sqlBuf.append(" '" + bo.getEriZPSTRU() + "' ,");
/* 249 */       sqlBuf.append(" '" + bo.getEriZPDTRU() + "' ,");
/* 250 */       sqlBuf.append(" '" + bo.getEriZPOther() + "' ,");
/* 251 */       sqlBuf.append(" '" + bo.getEriHFCDUA() + "' ,");
/* 252 */       sqlBuf.append(" '" + bo.getEriHFCDUCP() + "' ,");
/* 253 */       sqlBuf.append(" '" + bo.getEriHFCDUC() + "' ,");
/* 254 */       sqlBuf.append(" '" + bo.getEriHFCDUD() + "' ,");
/* 255 */       sqlBuf.append(" '" + bo.getEriHFCDUF9() + "' ,");
/* 256 */       sqlBuf.append(" '" + bo.getEriHFCDUG9() + "' ,");
/* 257 */       sqlBuf.append(" '" + bo.getEriHFOther() + "' ,");
/* 258 */       sqlBuf.append(" '" + bo.getEriDUX21() + "' ,");
/* 259 */       sqlBuf.append(" '" + bo.getEriDUX11() + "' ,");
/* 260 */       sqlBuf.append(" '" + bo.getEriDUX01() + "' ,");
/* 261 */       sqlBuf.append(" '" + bo.getEriDUXOther() + "' ,");
/*     */ 
/* 263 */       sqlBuf.append(" '" + bo.getHWZPTRU() + "' ,");
/* 264 */       sqlBuf.append(" '" + bo.getHWZPDRU() + "' ,");
/* 265 */       sqlBuf.append(" '" + bo.getHWZPDTRU() + "' ,");
/* 266 */       sqlBuf.append(" '" + bo.getHWZPOther() + "' ,");
/* 267 */       sqlBuf.append(" '" + bo.getHWHFCDUM900() + "' ,");
/* 268 */       sqlBuf.append(" '" + bo.getHWHFOther() + "' ,");
/* 269 */       sqlBuf.append(" '" + bo.getHWHFOther1() + "' ,");
/* 270 */       sqlBuf.append(" '" + bo.getHWHFOther2() + "' ,");
/* 271 */       sqlBuf.append(" '" + bo.getHWTMU() + "' ,");
/* 272 */       sqlBuf.append(" '" + bo.getHWTMUOther() + "' ,");
/* 273 */       sqlBuf.append(" '" + bo.getHWPMU() + "' ,");
/* 274 */       sqlBuf.append(" '" + bo.getHWPMUOther() + "' ,");
/* 275 */       sqlBuf.append(" '" + bo.getHWPSU() + "' ,");
/* 276 */       sqlBuf.append(" '" + bo.getHWPSUOther() + "' ,");
/* 277 */       sqlBuf.append(" '" + this.sdf.format(new Date()) + "' ,");
/*     */ 
/* 279 */       sqlBuf.append(" '" + bo.getMemo() + "' ,");
/* 280 */       sqlBuf.append(" '" + bo.getSbtstype() + "' ,");
/* 281 */       sqlBuf.append(" '" + bo.getIsgovandarm() + "' ,");
/*     */ 
/* 283 */       sqlBuf.append(" '" + bo.getIsmainoroth() + "' )");
/* 284 */       log.info(sqlBuf.toString());
/* 285 */       this.dbcon.execUpdate(sqlBuf.toString());
/*     */     }
/*     */     catch (Exception e)
/*     */     {
/* 289 */       flag = false;
/* 290 */       e.printStackTrace();
/* 291 */       log.error(e.getMessage());
/*     */     }
/*     */     finally {
/* 294 */       dbConClose();
/*     */     }
/* 296 */     log.info("添加--BTS---结束");
/* 297 */     return flag;
/*     */   }
/*     */ 
/*     */   public boolean saveBTSNewBO(BTSNewBO bo)
/*     */   {
/* 302 */     log.info("添加--BTS---开始");
/* 303 */     boolean flag = true;
/*     */     try
/*     */     {
/* 306 */       dbConInit();
/* 307 */       StringBuffer sqlBuf = new StringBuffer();
/* 308 */       sqlBuf.append(" insert into bts_new (btsname,frequency, btscode, BSC, manufacturer, cabinet, primdevicetype, ");
/* 309 */       sqlBuf.append("btscfg, frequencyNum, combinerType, combinerNum, primContrmodel, primContrNum, ");
/* 310 */       sqlBuf.append("powerPanelType, powerPanelNum, powerType, ele2Mnum, registtime, antennaType, ");
/* 311 */       sqlBuf.append("antennaFac, antennaNum, antennaGain, antennaDirect, antennaPolar, antennaHeight,");
/* 312 */       sqlBuf.append("antennaPre, antennaAngle, antennaPitchAngle, feederType, other1, other2, ");
/* 313 */       sqlBuf.append("other3, other4, IDUType, IDUNum, ODUType, ODUNum, refreshtime, memo ) values ( ");
/* 314 */       sqlBuf.append(" '" + bo.getBtsname() + "' ,");
/* 315 */       sqlBuf.append(" '" + bo.getFrequency() + "' ,");
/* 316 */       sqlBuf.append(" '" + bo.getBtscode() + "' ,");
/* 317 */       sqlBuf.append(" '" + bo.getBSC() + "' ,");
/* 318 */       sqlBuf.append(" '" + bo.getManufacturer() + "' ,");
/* 319 */       sqlBuf.append(" '" + bo.getCabinet() + "' ,");
/* 320 */       sqlBuf.append(" '" + bo.getPrimdevicetype() + "' ,");
/* 321 */       sqlBuf.append(" '" + bo.getBtscfg() + "' ,");
/* 322 */       sqlBuf.append(" '" + bo.getFrequencyNum() + "' ,");
/* 323 */       sqlBuf.append(" '" + bo.getCombinerType() + "' ,");
/* 324 */       sqlBuf.append(" '" + bo.getCombinerNum() + "' ,");
/* 325 */       sqlBuf.append(" '" + bo.getPrimContrmodel() + "' ,");
/* 326 */       sqlBuf.append(" '" + bo.getPrimContrNum() + "' ,");
/* 327 */       sqlBuf.append(" '" + bo.getPowerPanelType() + "' ,");
/* 328 */       sqlBuf.append(" '" + bo.getPowerPanelNum() + "' ,");
/* 329 */       sqlBuf.append(" '" + bo.getPowerType() + "' ,");
/* 330 */       sqlBuf.append(" '" + bo.getEle2Mnum() + "' ,");
/* 331 */       sqlBuf.append(" '" + this.sdfNet.format(bo.getRegisttime()) + "' ,");
/* 332 */       sqlBuf.append(" '" + bo.getAntennaType() + "' ,");
/* 333 */       sqlBuf.append(" '" + bo.getAntennaFac() + "' ,");
/* 334 */       sqlBuf.append(" '" + bo.getAntennaNum() + "' ,");
/* 335 */       sqlBuf.append(" '" + bo.getAntennaGain() + "' ,");
/* 336 */       sqlBuf.append(" '" + bo.getAntennaDirect() + "' ,");
/* 337 */       sqlBuf.append(" '" + bo.getAntennaPolar() + "' ,");
/* 338 */       sqlBuf.append(" '" + bo.getAntennaHeight() + "' ,");
/* 339 */       sqlBuf.append(" '" + bo.getAntennaPre() + "' ,");
/* 340 */       sqlBuf.append(" '" + bo.getAntennaAngle() + "' ,");
/* 341 */       sqlBuf.append(" '" + bo.getAntennaPitchAngle() + "' ,");
/* 342 */       sqlBuf.append(" '" + bo.getFeederType() + "' ,");
/* 343 */       sqlBuf.append(" '" + bo.getOther1() + "' ,");
/* 344 */       sqlBuf.append(" '" + bo.getOther2() + "' ,");
/* 345 */       sqlBuf.append(" '" + bo.getOther3() + "' ,");
/* 346 */       sqlBuf.append(" '" + bo.getOther4() + "' ,");
/* 347 */       sqlBuf.append(" '" + bo.getIDUType() + "' ,");
/* 348 */       sqlBuf.append(" '" + bo.getIDUNum() + "' ,");
/* 349 */       sqlBuf.append(" '" + bo.getODUType() + "' ,");
/* 350 */       sqlBuf.append(" '" + bo.getODUNum() + "' ,");
/* 351 */       sqlBuf.append(" '" + this.sdfNet.format(new Date()) + "' ,");
/* 352 */       sqlBuf.append(" '" + bo.getMemo() + "' )");
/* 353 */       log.info(sqlBuf.toString());
/* 354 */       this.dbcon.execUpdate(sqlBuf.toString());
/*     */     }
/*     */     catch (Exception e)
/*     */     {
/* 358 */       flag = false;
/* 359 */       e.printStackTrace();
/* 360 */       log.error(e.getMessage());
/*     */     }
/*     */     finally {
/* 363 */       dbConClose();
/*     */     }
/* 365 */     log.info("添加--BTS---结束");
/* 366 */     return flag;
/*     */   }
/*     */ 
/*     */   public boolean updateBTS(BTSBO bo)
/*     */   {
/* 373 */     log.info("修改--BTS---开始");
/* 374 */     boolean flag = true;
/*     */     try
/*     */     {
/* 377 */       dbConInit();
/* 378 */       StringBuffer sqlBuf = new StringBuffer();
/* 379 */       sqlBuf.append(" update bts set ");
/* 380 */       sqlBuf.append(" frequency = '" + bo.getFrequency() + "' ,");
/* 381 */       sqlBuf.append(" manufacturer = '" + bo.getManufacturer() + "' ,");
/* 382 */       sqlBuf.append(" maintenanceT = '" + bo.getMaintenanceT() + "' ,");
/* 383 */       sqlBuf.append(" btstype = '" + bo.getBtstype() + "' ,");
/* 384 */       sqlBuf.append(" primdevicetype = '" + bo.getPrimdevicetype() + "' ,");
/* 385 */       sqlBuf.append(" cellNum = '" + bo.getCellNum() + "' ,");
/* 386 */       sqlBuf.append(" BSC = '" + bo.getBSC() + "' ,");
/* 387 */       sqlBuf.append(" isVIP = '" + bo.getIsVIP() + "' ,");
/* 388 */       sqlBuf.append(" cabinet = '" + bo.getCabinet() + "' ,");
/* 389 */       sqlBuf.append(" btscfg = '" + bo.getBtscfg() + "' ,");
/* 390 */       sqlBuf.append(" frequencyNum = '" + bo.getFrequencyNum() + "' ,");
/* 391 */       sqlBuf.append(" nettingtime ='" + this.sdfNet.format(bo.getNettingtime()) + "' ,");
/* 392 */       sqlBuf.append(" primdevicemodel = '" + bo.getPrimdevicemodel() + "' ,");
/* 393 */       sqlBuf.append(" ele2Mnum = '" + bo.getEle2Mnum() + "' ,");
/* 394 */       sqlBuf.append(" primdevicehis = '" + bo.getPrimdevicehis() + "' ,");
/* 395 */       sqlBuf.append(" eriZPTRU = \t'" + bo.getEriZPTRU() + "' ,");
/* 396 */       sqlBuf.append(" eriZPSTRU = '" + bo.getEriZPSTRU() + "' ,");
/* 397 */       sqlBuf.append(" eriZPDTRU = '" + bo.getEriZPDTRU() + "' ,");
/* 398 */       sqlBuf.append(" eriZPOther = '" + bo.getEriZPOther() + "' ,");
/* 399 */       sqlBuf.append(" eriHFCDUA = '" + bo.getEriHFCDUA() + "' ,");
/* 400 */       sqlBuf.append(" eriHFCDUCP = '" + bo.getEriHFCDUCP() + "' ,");
/* 401 */       sqlBuf.append(" eriHFCDUC = '" + bo.getEriHFCDUC() + "' ,");
/* 402 */       sqlBuf.append(" eriHFCDUD = '" + bo.getEriHFCDUD() + "' ,");
/* 403 */       sqlBuf.append(" eriHFCDUF9 = '" + bo.getEriHFCDUF9() + "' ,");
/* 404 */       sqlBuf.append(" eriHFCDUG9 = '" + bo.getEriHFCDUG9() + "' ,");
/* 405 */       sqlBuf.append(" eriHFOther = '" + bo.getEriHFOther() + "' ,");
/*     */ 
/* 407 */       sqlBuf.append(" eriDUX21 = '" + bo.getEriDUX21() + "' ,");
/* 408 */       sqlBuf.append(" eriDUX11 = '" + bo.getEriDUX11() + "' ,");
/* 409 */       sqlBuf.append(" eriDUX01 = '" + bo.getEriDUX01() + "' ,");
/* 410 */       sqlBuf.append(" eriDUXOther = '" + bo.getEriDUXOther() + "' ,");
/*     */ 
/* 412 */       sqlBuf.append(" HWZPTRU = '" + bo.getHWZPTRU() + "' ,");
/* 413 */       sqlBuf.append(" HWZPDRU = '" + bo.getHWZPDRU() + "' ,");
/* 414 */       sqlBuf.append(" HWZPDTRU = '" + bo.getHWZPDTRU() + "' ,");
/* 415 */       sqlBuf.append(" HWZPOther = '" + bo.getHWZPOther() + "' ,");
/* 416 */       sqlBuf.append(" HWHFCDUM900 = '" + bo.getHWHFCDUM900() + "' ,");
/* 417 */       sqlBuf.append(" HWHFOther = '" + bo.getHWHFOther() + "' ,");
/* 418 */       sqlBuf.append(" HWHFOther1 = '" + bo.getHWHFOther1() + "' ,");
/* 419 */       sqlBuf.append(" HWHFOther2 = '" + bo.getHWHFOther2() + "' ,");
/* 420 */       sqlBuf.append(" HWTMU = '" + bo.getHWTMU() + "' ,");
/* 421 */       sqlBuf.append(" HWTMUOther = '" + bo.getHWTMUOther() + "' ,");
/* 422 */       sqlBuf.append(" HWPMU = '" + bo.getHWPMU() + "' ,");
/* 423 */       sqlBuf.append(" HWPMUOther = '" + bo.getHWPMUOther() + "' ,");
/* 424 */       sqlBuf.append(" HWPSU = '" + bo.getHWPSU() + "' ,");
/* 425 */       sqlBuf.append(" HWPSUOther = '" + bo.getHWPSUOther() + "' ,");
/* 426 */       sqlBuf.append(" refreshtime = '" + this.sdf.format(new Date()) + "' ,");
/*     */ 
/* 428 */       sqlBuf.append(" memo = '" + bo.getMemo() + "' ,");
/* 429 */       sqlBuf.append(" sbtstype = '" + bo.getSbtstype() + "' ,");
/* 430 */       sqlBuf.append(" isgovandarm = '" + bo.getIsgovandarm() + "' ,");
/*     */ 
/* 432 */       sqlBuf.append(" ismainoroth = '" + bo.getIsmainoroth() + "'  ");
/* 433 */       sqlBuf.append(" where id = '" + bo.getId() + "' ");
/* 434 */       log.info(sqlBuf.toString());
/* 435 */       this.dbcon.execUpdate(sqlBuf.toString());
/*     */     }
/*     */     catch (Exception e)
/*     */     {
/* 439 */       flag = false;
/* 440 */       e.printStackTrace();
/* 441 */       log.error(e.getMessage());
/*     */     }
/*     */     finally {
/* 444 */       dbConClose();
/*     */     }
/* 446 */     log.info("修改--BTS---结束");
/* 447 */     return flag;
/*     */   }
/*     */ 
/*     */   public boolean updateBTSNewBO(BTSNewBO bo)
/*     */   {
/* 453 */     log.info("修改--BTS---开始");
/* 454 */     boolean flag = true;
/*     */     try
/*     */     {
/* 457 */       dbConInit();
/* 458 */       StringBuffer sqlBuf = new StringBuffer();
/* 459 */       sqlBuf.append(" update  bts_new set ");
/* 460 */       sqlBuf.append(" frequency = '" + bo.getFrequency() + "' ,");
/* 461 */       sqlBuf.append(" BSC = '" + bo.getBSC() + "' ,");
/* 462 */       sqlBuf.append(" manufacturer = '" + bo.getManufacturer() + "' ,");
/* 463 */       sqlBuf.append(" cabinet = '" + bo.getCabinet() + "' ,");
/* 464 */       sqlBuf.append(" primdevicetype = '" + bo.getPrimdevicetype() + "' ,");
/* 465 */       sqlBuf.append(" btscfg = '" + bo.getBtscfg() + "' ,");
/* 466 */       sqlBuf.append(" frequencyNum = '" + bo.getFrequencyNum() + "' ,");
/* 467 */       sqlBuf.append(" combinerType = '" + bo.getCombinerType() + "' ,");
/* 468 */       sqlBuf.append(" combinerNum = '" + bo.getCombinerNum() + "' ,");
/* 469 */       sqlBuf.append(" primContrmodel = '" + bo.getPrimContrmodel() + "' ,");
/* 470 */       sqlBuf.append(" primContrNum = '" + bo.getPrimContrNum() + "' ,");
/* 471 */       sqlBuf.append(" powerPanelType = '" + bo.getPowerPanelType() + "' ,");
/* 472 */       sqlBuf.append(" powerPanelNum = '" + bo.getPowerPanelNum() + "' ,");
/* 473 */       sqlBuf.append(" powerType = '" + bo.getPowerType() + "' ,");
/* 474 */       sqlBuf.append(" ele2Mnum = '" + bo.getEle2Mnum() + "' ,");
/* 475 */       sqlBuf.append(" registtime = '" + this.sdfNet.format(bo.getRegisttime()) + "' ,");
/* 476 */       sqlBuf.append(" antennaType = '" + bo.getAntennaType() + "' ,");
/* 477 */       sqlBuf.append(" antennaFac = '" + bo.getAntennaFac() + "' ,");
/* 478 */       sqlBuf.append(" antennaNum = '" + bo.getAntennaNum() + "' ,");
/* 479 */       sqlBuf.append(" antennaGain = '" + bo.getAntennaGain() + "' ,");
/* 480 */       sqlBuf.append(" antennaDirect = '" + bo.getAntennaDirect() + "' ,");
/* 481 */       sqlBuf.append(" antennaPolar = '" + bo.getAntennaPolar() + "' ,");
/* 482 */       sqlBuf.append(" antennaHeight = '" + bo.getAntennaHeight() + "' ,");
/* 483 */       sqlBuf.append(" antennaPre = '" + bo.getAntennaPre() + "' ,");
/* 484 */       sqlBuf.append(" antennaAngle = '" + bo.getAntennaAngle() + "' ,");
/* 485 */       sqlBuf.append(" antennaPitchAngle = '" + bo.getAntennaPitchAngle() + "' ,");
/* 486 */       sqlBuf.append(" feederType = '" + bo.getFeederType() + "' ,");
/* 487 */       sqlBuf.append(" other1 = '" + bo.getOther1() + "' ,");
/* 488 */       sqlBuf.append(" other2 = '" + bo.getOther2() + "' ,");
/* 489 */       sqlBuf.append(" other3 = '" + bo.getOther3() + "' ,");
/* 490 */       sqlBuf.append(" other4 = '" + bo.getOther4() + "' ,");
/* 491 */       sqlBuf.append(" IDUType = '" + bo.getIDUType() + "' ,");
/* 492 */       sqlBuf.append(" IDUNum = '" + bo.getIDUNum() + "' ,");
/* 493 */       sqlBuf.append(" ODUType = '" + bo.getODUType() + "' ,");
/* 494 */       sqlBuf.append(" ODUNum = '" + bo.getODUNum() + "' ,");
/* 495 */       sqlBuf.append(" refreshtime = '" + this.sdfNet.format(new Date()) + "' ,");
/* 496 */       sqlBuf.append(" memo = '" + bo.getMemo() + "' ");
/* 497 */       sqlBuf.append(" where id = '" + bo.getId() + "' ");
/* 498 */       log.info(sqlBuf.toString());
/* 499 */       this.dbcon.execUpdate(sqlBuf.toString());
/*     */     }
/*     */     catch (Exception e)
/*     */     {
/* 503 */       flag = false;
/* 504 */       e.printStackTrace();
/* 505 */       log.error(e.getMessage());
/*     */     }
/*     */     finally {
/* 508 */       dbConClose();
/*     */     }
/* 510 */     log.info("修改--BTS---结束");
/* 511 */     return flag;
/*     */   }
/*     */ 
/*     */   public boolean deleteBTS(String strID)
/*     */   {
/* 517 */     log.info("删除--BTS---开始");
/* 518 */     boolean flag = true;
/*     */     try
/*     */     {
/* 521 */       dbConInit();
/* 522 */       StringBuffer sqlBuf = new StringBuffer();
/* 523 */       sqlBuf.append(" delete from bts   ");
/* 524 */       sqlBuf.append(" where id = '" + strID + "' ");
/* 525 */       log.info(sqlBuf.toString());
/* 526 */       this.dbcon.execUpdate(sqlBuf.toString());
/*     */     }
/*     */     catch (Exception e)
/*     */     {
/* 530 */       flag = false;
/* 531 */       e.printStackTrace();
/* 532 */       log.error(e.getMessage());
/*     */     }
/*     */     finally {
/* 535 */       dbConClose();
/*     */     }
/* 537 */     log.info("删除--BTS---结束");
/* 538 */     return flag;
/*     */   }
/*     */ 
/*     */   public boolean deleteBTSNewBO(String strID)
/*     */   {
/* 543 */     log.info("删除--BTS---开始");
/* 544 */     boolean flag = true;
/*     */     try
/*     */     {
/* 547 */       dbConInit();
/* 548 */       StringBuffer sqlBuf = new StringBuffer();
/* 549 */       sqlBuf.append(" delete from bts_new   ");
/* 550 */       sqlBuf.append(" where id = '" + strID + "' ");
/* 551 */       log.info(sqlBuf.toString());
/* 552 */       this.dbcon.execUpdate(sqlBuf.toString());
/*     */     }
/*     */     catch (Exception e)
/*     */     {
/* 556 */       flag = false;
/* 557 */       e.printStackTrace();
/* 558 */       log.error(e.getMessage());
/*     */     }
/*     */     finally {
/* 561 */       dbConClose();
/*     */     }
/* 563 */     log.info("删除--BTS---结束");
/* 564 */     return flag;
/*     */   }
/*     */ 
/*     */   public ListContentsBFO getBTSByBtsName(Map condition)
/*     */   {
/* 570 */     ListContentsBFO bfo = new ListContentsBFO();
/* 571 */     int start = Integer.parseInt(condition.get("start").toString());
/* 572 */     int limit = Integer.parseInt(condition.get("limit").toString());
/* 573 */     String strBtsName = condition.get("btsName").toString();
/* 574 */     ResultSet rs = null;
/* 575 */     List list = new ArrayList();
/*     */     try
/*     */     {
/* 578 */       dbConInit();
/*     */ 
/* 580 */       Object objRegistBeginTime = condition.get("registBeginTime");
/* 581 */       Object objRegistEndTime = condition.get("registEndTime");
/* 582 */       if ((objRegistBeginTime == null) || ("".equalsIgnoreCase(objRegistBeginTime.toString().trim())))
/* 583 */         objRegistBeginTime = null;
/* 584 */       if ((objRegistEndTime == null) || ("".equalsIgnoreCase(objRegistEndTime.toString().trim()))) {
/* 585 */         objRegistEndTime = null;
/*     */       }
/* 587 */       String strSQL = " select count(id) from bts where btsname like '%" + strBtsName + "%' ";
/* 588 */       if ((objRegistBeginTime != null) && (objRegistEndTime != null))
/* 589 */         strSQL = strSQL + " and '" + objRegistEndTime.toString() + "'>= registtime and  registtime >= '" + objRegistBeginTime.toString() + "' ";
/* 590 */       else if ((objRegistBeginTime == null) && (objRegistEndTime != null))
/* 591 */         strSQL = strSQL + " and '" + objRegistEndTime.toString() + "' >= registtime ";
/* 592 */       else if ((objRegistBeginTime != null) && (objRegistEndTime == null))
/* 593 */         strSQL = strSQL + " and registtime >= '" + objRegistBeginTime.toString() + "'  ";
/* 594 */       log.info(strSQL);
/* 595 */       rs = this.dbcon.execQuery(strSQL);
/* 596 */       if (rs.next()) {
/* 597 */         bfo.setTotalSize(rs.getInt(1));
/*     */       }
/* 599 */       strSQL = " select * from bts where btsname like '%" + strBtsName + "%' limit " + start + ", " + limit;
/* 600 */       if ((objRegistBeginTime != null) && (objRegistEndTime != null))
/* 601 */         strSQL = strSQL + " and '" + objRegistEndTime.toString() + "'>= registtime and  registtime >= '" + objRegistBeginTime.toString() + "' ";
/* 602 */       else if ((objRegistBeginTime == null) && (objRegistEndTime != null))
/* 603 */         strSQL = strSQL + " and '" + objRegistEndTime.toString() + "' >= registtime ";
/* 604 */       else if ((objRegistBeginTime != null) && (objRegistEndTime == null))
/* 605 */         strSQL = strSQL + " and registtime >= '" + objRegistBeginTime.toString() + "'  ";
/* 606 */       log.info(strSQL);
/* 607 */       rs = this.dbcon.execQuery(strSQL);
/* 608 */       while (rs.next()) {
/* 609 */         BTSBO bo = new BTSBO();
/* 610 */         bo.setId(rs.getString("id"));
/* 611 */         bo.setBtscode(rs.getString("btscode"));
/* 612 */         bo.setBtsname(rs.getString("btsname"));
/* 613 */         bo.setFrequency(rs.getString("frequency"));
/* 614 */         bo.setManufacturer(rs.getString("manufacturer"));
/* 615 */         bo.setMaintenanceT(rs.getString("maintenanceT"));
/* 616 */         bo.setBtstype(rs.getString("btstype"));
/* 617 */         bo.setPrimdevicetype(rs.getString("primdevicetype"));
/*     */ 
/* 619 */         bo.setCellNum(rs.getString("cellNum"));
/* 620 */         bo.setBSC(rs.getString("BSC"));
/* 621 */         bo.setIsVIP(rs.getString("isVIP"));
/* 622 */         bo.setCabinet(rs.getString("cabinet"));
/* 623 */         bo.setBtscfg(rs.getString("btscfg"));
/* 624 */         bo.setFrequencyNum(rs.getString("frequencyNum"));
/* 625 */         bo.setNettingtime(rs.getDate("nettingtime"));
/*     */ 
/* 627 */         bo.setPrimdevicemodel(rs.getString("primdevicemodel"));
/* 628 */         bo.setEle2Mnum(rs.getString("ele2Mnum"));
/* 629 */         bo.setPrimdevicehis(rs.getString("primdevicehis"));
/*     */ 
/* 631 */         bo.setEriZPTRU(rs.getString("eriZPTRU"));
/* 632 */         bo.setEriZPSTRU(rs.getString("eriZPSTRU"));
/* 633 */         bo.setEriZPDTRU(rs.getString("eriZPDTRU"));
/* 634 */         bo.setEriZPOther(rs.getString("eriZPOther"));
/* 635 */         bo.setEriHFCDUA(rs.getString("eriHFCDUA"));
/* 636 */         bo.setEriHFCDUCP(rs.getString("eriHFCDUCP"));
/* 637 */         bo.setEriHFCDUC(rs.getString("eriHFCDUC"));
/* 638 */         bo.setEriHFCDUD(rs.getString("eriHFCDUD"));
/* 639 */         bo.setEriHFCDUF9(rs.getString("eriHFCDUF9"));
/* 640 */         bo.setEriHFCDUG9(rs.getString("eriHFCDUG9"));
/* 641 */         bo.setEriHFOther(rs.getString("eriHFOther"));
/* 642 */         bo.setEriDUX21(rs.getString("eriDUX21"));
/* 643 */         bo.setEriDUX11(rs.getString("eriDUX11"));
/* 644 */         bo.setEriDUX01(rs.getString("eriDUX01"));
/* 645 */         bo.setEriDUXOther(rs.getString("eriDUXOther"));
/*     */ 
/* 647 */         bo.setHWZPTRU(rs.getString("HWZPTRU"));
/* 648 */         bo.setHWZPDRU(rs.getString("HWZPDRU"));
/* 649 */         bo.setHWZPDTRU(rs.getString("HWZPDTRU"));
/* 650 */         bo.setHWZPOther(rs.getString("HWZPOther"));
/* 651 */         bo.setHWHFCDUM900(rs.getString("HWHFCDUM900"));
/* 652 */         bo.setHWHFOther(rs.getString("HWHFOther"));
/* 653 */         bo.setHWHFOther1(rs.getString("HWHFOther1"));
/* 654 */         bo.setHWHFOther2(rs.getString("HWHFOther2"));
/* 655 */         bo.setHWTMU(rs.getString("HWTMU"));
/* 656 */         bo.setHWTMUOther(rs.getString("HWTMUOther"));
/* 657 */         bo.setHWPMU(rs.getString("HWPMU"));
/* 658 */         bo.setHWPMUOther(rs.getString("HWPMUOther"));
/* 659 */         bo.setHWPSU(rs.getString("HWPSU"));
/* 660 */         bo.setHWPSUOther(rs.getString("HWPSUOther"));
/*     */ 
/* 662 */         bo.setRefreshtime(rs.getDate("refreshtime"));
/* 663 */         bo.setMemo(rs.getString("memo"));
/* 664 */         bo.setSbtstype(rs.getString("sbtstype"));
/* 665 */         bo.setIsgovandarm(rs.getString("isgovandarm"));
/* 666 */         bo.setIsmainoroth(rs.getString("ismainoroth"));
/*     */ 
/* 669 */         list.add(bo);
/*     */       }
/* 671 */       bfo.setData(list.toArray());
/*     */     }
/*     */     catch (Exception e) {
/* 674 */       e.printStackTrace();
/* 675 */       log.error(e.getMessage());
/*     */     }
/*     */     finally {
/* 678 */       dbConClose();
/*     */     }
/* 680 */     return bfo;
/*     */   }
/*     */ 
/*     */   public ListContentsBFO getBTSNewBOByBtsName(Map condition)
/*     */   {
/* 686 */     ListContentsBFO bfo = new ListContentsBFO();
/* 687 */     int start = Integer.parseInt(condition.get("start").toString());
/* 688 */     int limit = Integer.parseInt(condition.get("limit").toString());
/* 689 */     String strBtsName = condition.get("btsName").toString();
/* 690 */     ResultSet rs = null;
/* 691 */     List list = new ArrayList();
/*     */     try
/*     */     {
/* 694 */       dbConInit();
/*     */ 
/* 696 */       Object objRegistBeginTime = condition.get("registBeginTime");
/* 697 */       Object objRegistEndTime = condition.get("registEndTime");
/* 698 */       String strSQL = " select count(id) from bts_new where btsname like '%" + strBtsName + "%' or manufacturer like '%" + strBtsName + "%'";
/* 699 */       strSQL = FormateSQL.getFormateSQL(objRegistBeginTime, objRegistEndTime, strSQL);
/* 700 */       log.info(strSQL);
/* 701 */       rs = this.dbcon.execQuery(strSQL);
/* 702 */       if (rs.next()) {
/* 703 */         bfo.setTotalSize(rs.getInt(1));
/*     */       }
/* 705 */       strSQL = " select * from bts_new where ( btsname like '%" + strBtsName + "%' or manufacturer like '%" + strBtsName + "%' )";
/* 706 */       strSQL = FormateSQL.getFormateSQL(objRegistBeginTime, objRegistEndTime, strSQL);
/* 707 */       strSQL = strSQL + "limit " + start + ", " + limit;
/* 708 */       log.info(strSQL);
/* 709 */       rs = this.dbcon.execQuery(strSQL);
/* 710 */       while (rs.next()) {
/* 711 */         BTSNewBO bo = new BTSNewBO();
/* 712 */         bo.setId(rs.getString("id"));
/* 713 */         bo.setBtsname(rs.getString("btsname"));
/* 714 */         bo.setFrequency(rs.getString("frequency"));
/* 715 */         bo.setBtscode(rs.getString("btscode"));
/* 716 */         bo.setBSC(rs.getString("BSC"));
/* 717 */         bo.setManufacturer(rs.getString("manufacturer"));
/* 718 */         bo.setCabinet(rs.getString("cabinet"));
/* 719 */         bo.setPrimdevicetype(rs.getString("primdevicetype"));
/* 720 */         bo.setBtscfg(rs.getString("btscfg"));
/* 721 */         bo.setFrequencyNum(rs.getString("frequencyNum"));
/* 722 */         bo.setCombinerType(rs.getString("combinerType"));
/* 723 */         bo.setCombinerNum(rs.getString("combinerNum"));
/* 724 */         bo.setPrimContrmodel(rs.getString("primContrmodel"));
/* 725 */         bo.setPrimContrNum(rs.getString("primContrNum"));
/* 726 */         bo.setPowerPanelType(rs.getString("powerPanelType"));
/* 727 */         bo.setPowerPanelNum(rs.getString("powerPanelNum"));
/* 728 */         bo.setPowerType(rs.getString("powerType"));
/* 729 */         bo.setEle2Mnum(rs.getString("ele2Mnum"));
/* 730 */         bo.setRegisttime(rs.getDate("registtime"));
/* 731 */         bo.setAntennaType(rs.getString("antennaType"));
/* 732 */         bo.setAntennaFac(rs.getString("antennaFac"));
/* 733 */         bo.setAntennaNum(rs.getString("antennaNum"));
/* 734 */         bo.setAntennaGain(rs.getString("antennaGain"));
/* 735 */         bo.setAntennaDirect(rs.getString("antennaDirect"));
/* 736 */         bo.setAntennaPolar(rs.getString("antennaPolar"));
/* 737 */         bo.setAntennaHeight(rs.getString("antennaHeight"));
/* 738 */         bo.setAntennaPre(rs.getString("antennaPre"));
/* 739 */         bo.setAntennaAngle(rs.getString("antennaAngle"));
/* 740 */         bo.setAntennaPitchAngle(rs.getString("antennaPitchAngle"));
/* 741 */         bo.setFeederType(rs.getString("feederType"));
/* 742 */         bo.setOther1(rs.getString("other1"));
/* 743 */         bo.setOther2(rs.getString("other2"));
/* 744 */         bo.setOther3(rs.getString("other3"));
/* 745 */         bo.setOther4(rs.getString("other4"));
/* 746 */         bo.setIDUType(rs.getString("IDUType"));
/* 747 */         bo.setIDUNum(rs.getString("IDUNum"));
/* 748 */         bo.setODUType(rs.getString("ODUType"));
/* 749 */         bo.setODUNum(rs.getString("ODUNum"));
/* 750 */         bo.setRefreshtime(rs.getDate("refreshtime"));
/* 751 */         bo.setMemo(rs.getString("memo"));
/* 752 */         list.add(bo);
/*     */       }
/* 754 */       bfo.setData(list.toArray());
/*     */     }
/*     */     catch (Exception e) {
/* 757 */       e.printStackTrace();
/* 758 */       log.error(e.getMessage());
/*     */     }
/*     */     finally {
/* 761 */       dbConClose();
/*     */     }
/* 763 */     return bfo;
/*     */   }
/*     */ 
/*     */   public List exportBTS(String strBtsName, String strRegistBeginTime, String strRegistEndTime)
/*     */   {
/* 769 */     ResultSet rs = null;
/* 770 */     List list = new ArrayList();
/*     */     try
/*     */     {
/* 773 */       dbConInit();
/*     */ 
/* 840 */       String strSQL = " select * from bts_new where ( btsname like '%" + strBtsName + "%' or manufacturer like '%" + strBtsName + "%' )";
/* 841 */       strSQL = FormateSQL.getFormateSQL(strRegistBeginTime, strRegistEndTime, strSQL);
/* 842 */       log.info(strSQL);
/* 843 */       rs = this.dbcon.execQuery(strSQL);
/* 844 */       while (rs.next()) {
/* 845 */         BTSNewBO bo = new BTSNewBO();
/* 846 */         bo.setId(rs.getString("id"));
/* 847 */         bo.setBtsname(rs.getString("btsname"));
/* 848 */         bo.setFrequency(rs.getString("frequency"));
/* 849 */         bo.setBtscode(rs.getString("btscode"));
/* 850 */         bo.setBSC(rs.getString("BSC"));
/* 851 */         bo.setManufacturer(rs.getString("manufacturer"));
/* 852 */         bo.setCabinet(rs.getString("cabinet"));
/* 853 */         bo.setPrimdevicetype(rs.getString("primdevicetype"));
/* 854 */         bo.setBtscfg(rs.getString("btscfg"));
/* 855 */         bo.setFrequencyNum(rs.getString("frequencyNum"));
/* 856 */         bo.setCombinerType(rs.getString("combinerType"));
/* 857 */         bo.setCombinerNum(rs.getString("combinerNum"));
/* 858 */         bo.setPrimContrmodel(rs.getString("primContrmodel"));
/* 859 */         bo.setPrimContrNum(rs.getString("primContrNum"));
/* 860 */         bo.setPowerPanelType(rs.getString("powerPanelType"));
/* 861 */         bo.setPowerPanelNum(rs.getString("powerPanelNum"));
/* 862 */         bo.setPowerType(rs.getString("powerType"));
/* 863 */         bo.setEle2Mnum(rs.getString("ele2Mnum"));
/* 864 */         bo.setRegisttime(rs.getDate("registtime"));
/* 865 */         bo.setAntennaType(rs.getString("antennaType"));
/* 866 */         bo.setAntennaFac(rs.getString("antennaFac"));
/* 867 */         bo.setAntennaNum(rs.getString("antennaNum"));
/* 868 */         bo.setAntennaGain(rs.getString("antennaGain"));
/* 869 */         bo.setAntennaDirect(rs.getString("antennaDirect"));
/* 870 */         bo.setAntennaPolar(rs.getString("antennaPolar"));
/* 871 */         bo.setAntennaHeight(rs.getString("antennaHeight"));
/* 872 */         bo.setAntennaPre(rs.getString("antennaPre"));
/* 873 */         bo.setAntennaAngle(rs.getString("antennaAngle"));
/* 874 */         bo.setAntennaPitchAngle(rs.getString("antennaPitchAngle"));
/* 875 */         bo.setFeederType(rs.getString("feederType"));
/* 876 */         bo.setOther1(rs.getString("other1"));
/* 877 */         bo.setOther2(rs.getString("other2"));
/* 878 */         bo.setOther3(rs.getString("other3"));
/* 879 */         bo.setOther4(rs.getString("other4"));
/* 880 */         bo.setIDUType(rs.getString("IDUType"));
/* 881 */         bo.setIDUNum(rs.getString("IDUNum"));
/* 882 */         bo.setODUType(rs.getString("ODUType"));
/* 883 */         bo.setODUNum(rs.getString("ODUNum"));
/* 884 */         bo.setRefreshtime(rs.getDate("refreshtime"));
/* 885 */         bo.setMemo(rs.getString("memo"));
/* 886 */         list.add(bo);
/*     */       }
/*     */ 
/*     */     }
/*     */     catch (Exception e)
/*     */     {
/* 892 */       e.printStackTrace();
/* 893 */       log.error(e.getMessage());
/*     */     }
/*     */     finally {
/* 896 */       dbConClose();
/*     */     }
/* 898 */     return list;
/*     */   }
/*     */ 
/*     */   public List exportBTSNewBO(String strBtsName)
/*     */   {
/* 903 */     ResultSet rs = null;
/* 904 */     List list = new ArrayList();
/*     */     try
/*     */     {
/* 907 */       dbConInit();
/* 908 */       String strSQL = " select * from bts_new where btsname like '%" + strBtsName + "%'";
/* 909 */       log.info(strSQL);
/* 910 */       rs = this.dbcon.execQuery(strSQL);
/* 911 */       while (rs.next()) {
/* 912 */         BTSNewBO bo = new BTSNewBO();
/* 913 */         bo.setId(rs.getString("id"));
/* 914 */         bo.setBtsname(rs.getString("btsname"));
/* 915 */         bo.setFrequency(rs.getString("frequency"));
/* 916 */         bo.setBtscode(rs.getString("btscode"));
/* 917 */         bo.setBSC(rs.getString("BSC"));
/* 918 */         bo.setManufacturer(rs.getString("manufacturer"));
/* 919 */         bo.setCabinet(rs.getString("cabinet"));
/* 920 */         bo.setPrimdevicetype(rs.getString("primdevicetype"));
/* 921 */         bo.setBtscfg(rs.getString("btscfg"));
/* 922 */         bo.setFrequencyNum(rs.getString("frequencyNum"));
/* 923 */         bo.setCombinerType(rs.getString("combinerType"));
/* 924 */         bo.setCombinerNum(rs.getString("combinerNum"));
/* 925 */         bo.setPrimContrmodel(rs.getString("primContrmodel"));
/* 926 */         bo.setPrimContrNum(rs.getString("primContrNum"));
/* 927 */         bo.setPowerPanelType(rs.getString("powerPanelType"));
/* 928 */         bo.setPowerPanelNum(rs.getString("powerPanelNum"));
/* 929 */         bo.setPowerType(rs.getString("powerType"));
/* 930 */         bo.setEle2Mnum(rs.getString("ele2Mnum"));
/* 931 */         bo.setRegisttime(rs.getDate("registtime"));
/* 932 */         bo.setAntennaType(rs.getString("antennaType"));
/* 933 */         bo.setAntennaFac(rs.getString("antennaFac"));
/* 934 */         bo.setAntennaNum(rs.getString("antennaNum"));
/* 935 */         bo.setAntennaGain(rs.getString("antennaGain"));
/* 936 */         bo.setAntennaDirect(rs.getString("antennaDirect"));
/* 937 */         bo.setAntennaPolar(rs.getString("antennaPolar"));
/* 938 */         bo.setAntennaHeight(rs.getString("antennaHeight"));
/* 939 */         bo.setAntennaPre(rs.getString("antennaPre"));
/* 940 */         bo.setAntennaAngle(rs.getString("antennaAngle"));
/* 941 */         bo.setAntennaPitchAngle(rs.getString("antennaPitchAngle"));
/* 942 */         bo.setFeederType(rs.getString("feederType"));
/* 943 */         bo.setOther1(rs.getString("other1"));
/* 944 */         bo.setOther2(rs.getString("other2"));
/* 945 */         bo.setOther3(rs.getString("other3"));
/* 946 */         bo.setOther4(rs.getString("other4"));
/* 947 */         bo.setIDUType(rs.getString("IDUType"));
/* 948 */         bo.setIDUNum(rs.getString("IDUNum"));
/* 949 */         bo.setODUType(rs.getString("ODUType"));
/* 950 */         bo.setODUNum(rs.getString("ODUNum"));
/* 951 */         bo.setRefreshtime(rs.getDate("refreshtime"));
/* 952 */         bo.setMemo(rs.getString("memo"));
/* 953 */         list.add(bo);
/*     */       }
/*     */     }
/*     */     catch (Exception e) {
/* 957 */       e.printStackTrace();
/* 958 */       log.error(e.getMessage());
/*     */     }
/*     */     finally {
/* 961 */       dbConClose();
/*     */     }
/* 963 */     return list;
/*     */   }
/*     */ }

/* Location:           E:\java\apache-tomcat-6.0.36\webapps\btsm\WEB-INF\classes\
 * Qualified Name:     com.yc.dao.station.BTSDAO
 * JD-Core Version:    0.6.2
 */